HW#2 --- last modified February 17 2019 19:37:59..

Solution set.

Due date: Mar 4

Files to be submitted:
  Hw2.zip

Purpose: The lab part of this assignment will help you learn the basic DDL and DML commands for creating and querying DB2 databases. In particular, you will learn DB2 enhancements to basic SQL. The problems I am assigning for this homework are intended to help you solidify your knowledge of DB2 for z/OS table spaces, address spaces (particularly DBM1 and its components), and system architecture.

Related Course Outcomes:

The main course outcomes covered by this assignment are:

(1) Identify DB2 components and understand DB2 architecture.
(2) Describe the system environment of DB2 on z/OS, understand how DB2 cooperates with other facilities within this environment.
(3) Develop applications using DB2 on z/OS as a data server.

Specification:

Your Hw2.zip file should contain two main files: Assignment.html and Lab.php . The assignment file should contain your solutions to the multiple choice problems below. The lab file should contain transcripts and screenshots from your SPUFI and control center sessions as well as anything else needed to assignment the lab portion of the assignment.

Assignment Component

For this portion you should answer the following multiple choice problems. To do this you might need to examine the online DB2 Reference Center. Besides choosing what you think is the correct answer to each question you should provide a short explanation in your own words justifying your answer. An answer without a coherent justification will not receive any credit.

1. Table space1 is a segmented table space,. In this table space, there are three tables : tableA, tableB, and tableC. Assuming tableA uses 2.5 segments, tableB uses 3.2 segments, and tableC uses 3.3 segments. How many segments are used in Tablespace1?
   1. 8
   2. 9
   3. 10
   4. 11
2. Assuming table1 has 1 XML column and 1 LOB column, and Table2 has 2 LOB columns, how many LOB table spaces are needed to store the LOB columns in both Table1 and Table2?
   1. 1
   2. 2
   3. 3
   4. 4
3. Which of the following is a type of Universal Table space?
   1. Segmented
   2. Simple
   3. Partition-by-Growth
   4. None of the above
4. Which one is not a DB2 address space?
   1. IRLM
   2. MSTR
   3. DBM1
   4. IMS
5. Which of the following is the address space that provides the facility for the manipu-lation of DB2 data structures?
   1. MSTR
   2. DBAS
   3. SPAS
   4. DDF
6. Which of the following is true for the buffer manager?
   1. The buffer manager requests data from VSAM manager which retrieves data pages from DASD files.
   2. The buffer manager requests data from the data manager and index manager.
   3. The buffer manager maintains recently accessed data in virtual storage, so as to reduce I/O.
   4. The buffer manager analyzes the rows it receives and returns the appropriate re-sult to its caller.
   1. i, iii
   2. i, ii, iv
   3. ii, iii, iv
   4. All of the above
7. Which of the following is a responsibility of IRLM?
   1. Request a lock for a certain resource
   2. Prevent unauthorized access to data
   3. Deadlock detection
   4. None of the above
8. Which function is not performed by the DM?
   1. Data manipulation
   2. Index management
   3. Restart and recovery of data
   4. Allocate data set space
9. Which situation below is not likely to use list prefetch ?
   1. ISCAN with a cluster ratio lower than 50%
   2. Access data by multiple index access
   3. Access inner table data during a hybrid join
   4. Access inner table in a nested-loop join
10. Which function is not performed by RDS?
    1. Parser
    2. Authorization control
    3. Optimizer
    4. Load page

Lab Component

Varian has now posted Labs 3, 4, 5. To do the lab component of this homework, go through these labs answering the questions therein. Keep a transcript of your SPUFI sessions. Put these all into Lab.html).

Use the same manual method for creating html files as was used for Hw1.

Point Breakdown